begin
  dbms_scheduler.create_job(
      job_name => 'update_stock_job'
     ,job_type => 'PLSQL_BLOCK'
     ,job_action => 'begin pkg_stock.update_stock_data_history; end;'
     ,start_date => SYSTIMESTAMP
     ,end_date   => NULL
     ,repeat_interval => 'FREQ=DAILY;BYDAY=MON,FRI;BYHOUR=12;'
     ,enabled => true
     ,auto_drop => false
     ,comments => 'Update stock data at the end of trading date.');
end;

/
